package com.woniuxy.main.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;

import com.woniuxy.main.pojo.Facility;

public interface FacilityMapper {
	
	
	@Select("select * from facility where room_id=#{room_id} and flag=0")
	public List<Facility> getFacilityByRoomId(int room_id);

	
	
	//为房间添加设备
	@Insert("insert into facility(f_name,price,room_id) values(#{f_name},#{price},#{room_id})")
	public boolean addFacility(Facility facility);
	
	
}
